/**
* Copyright (C) 2018-2020
* All rights reserved, Designed By www.yixiang.co
* 注意：
* 本软件为www.yixiang.co开发研制，未经购买不得使用
* 购买后可获得全部源代码（禁止转卖、分享、上传到码云、github等开源平台）
* 一经发现盗用、分享等行为，将追究法律责任，后果自负
*/
package co.yixiang.modules.auction.service.mapper;

import co.yixiang.common.mapper.CoreMapper;
import co.yixiang.modules.auction.domain.YxAuctionMember;
import co.yixiang.modules.auction.service.dto.MemberLogDto;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

/**
* @author hupeng
* @date 2021-06-06
*/
@Repository
public interface YxAuctionMemberMapper extends CoreMapper<YxAuctionMember> {

    @Select(" SELECT yam.title , yam.time , yub.create_time as createTime from " +
            " yx_user_bill yub , yx_auction_member yam where yub.link_id = yam.id and " +
            " yub.title = '开通会员' and `status` = 1 and yub.uid = #{uid}  ORDER BY yub.create_time ")
    List<MemberLogDto> openMemberLog(@Param("uid") Long uid);
}
